{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Ejec PAC GPTR"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":1,"defined_names":6,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Ejec PAC GPTR","index":0,"n_rows":64,"n_cols":23,"rows_kept":64,"cut":false,"hidden":false,"merged":[[54,22,56,22],[54,13,56,16],[54,17,56,17],[54,18,56,18],[54,19,56,19],[54,20,56,20],[54,21,56,21],[40,13,49,22],[50,13,51,22],[52,13,53,16],[52,17,53,17],[52,18,53,18],[52,19,53,19],[52,20,53,20],[52,21,53,21],[52,22,53,22],[38,13,39,22],[27,1,27,22],[28,1,28,22],[29,1,29,22],[30,1,30,3],[31,1,31,3],[32,1,32,3],[33,1,33,3],[34,1,34,3],[35,1,35,3],[36,1,36,3],[37,1,37,22],[26,15,26,22],[24,1,24,22],[25,1,25,5],[25,6,25,7],[25,8,25,10],[25,11,25,17],[25,18,25,19],[25,20,25,22],[26,1,26,3],[26,4,26,5],[26,6,26,8],[26,9,26,10],[26,11,26,14],[17,1,17,22],[22,16,22,22],[23,4,23,5],[23,6,23,10],[23,12,23,15],[23,16,23,22],[21,1,21,3],[21,4,21,22],[22,1,23,3],[22,4,22,5],[22,6,22,10],[22,12,22,15],[14,1,14,4],[14,5,14,22],[15,1,15,4],[15,5,15,22],[16,1,16,22],[18,1,18,22],[19,1,19,3],[19,4,19,22],[20,1,20,3],[20,4,20,22],[13,5,13,22],[10,1,10,22],[1,1,3,4],[1,5,3,18],[1,19,1,22],[2,19,2,22],[3,19,3,22],[5,1,5,6],[5,8,5,14],[5,16,5,22],[11,1,11,4],[11,5,11,22],[12,1,12,4],[12,5,12,22],[13,1,13,4],[6,1,6,6],[6,11,6,12],[6,21,6,22],[7,21,7,22],[9,1,9,22]]}
[]
[null,null,null,null,null,"FORMATO: PRESENTACIÓN DE DATOS PARA SEGUIMIENTO Y MEDICIÓN\n\nPROCESO: MEJORAMIENTO CONTINUO",null,null,null,null,null,null,null,null,null,null,null,null,null,"Versión: 1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fecha: 22/12/2021"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Código: MC-F-013"]
[]
[null,"FECHA DE CORTE",null,null,null,null,null,null,"FECHA DE REPORTE",null,null,null,null,null,null,"*","RANGO PORCENTUAL -Depende de la Tendencia"]
[null,"MENSUAL",null,null,null,null,null,null,"Día",null,"Mes",null,null,"Año",null,"Ascendente","Inaceptable","0% - 74,9%","Satisfactorio","75% - 94,9%","Sobresaliente","95% - 100%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Descendente","Inaceptable","10% o más","Satisfactorio","3%- 9,99%","Sobresaliente","Menor a 3%"]
[]
[null,"1. IDENTIFICACIÓN DEL PROCESO"]
[]
[null,"PROCESO",null,null,null,"FINANCIERA"]
[null,"OBJETIVO DEL PROCESO ",null,null,null,{"$f":"IFERROR(+VLOOKUP(PROCES,[1]Hoja1!B4:C23,2,FALSE),\"\")","v":"Planear, analizar, verificar y registrar la ejecución de los recursos presupuestales asignados a la PGN, a traves de la aplicación de lineamientos presupuestales, financieros y contables para garantizar la oportunidad y adecuada administración de estos recursos conforme al marco legal vigente. "}]
[null,"DEPENDENCIA RESPONSABLE DEL SEGUIMIENTO",null,null,null,"DIVISION FINANCIERA"]
[null,"RESPONSABLE (S) DEL PROCESO ",null,null,null,"JEFE DIVISIÓN FINANCIERA"]
[null,"OBJETIVOS DE CALIDAD RELACIONADO",null,null,null,"Objetivo RFF2. Mejorar la planificación administrativa y financiera para el suministro oportuno y adecuado de bienes y servicios institucionales "]
[]
[null,"2. IDENTIFICACIÓN DEL INDICADOR"]
[]
[null,"NOMBRE DEL INDICADOR",null,null,"PAC NO UTILIZADO GASTOS DE PERSONAL Y TRANSFERENCIAS"]
[null,"OBJETIVO DEL INDICADOR",null,null,"Establecer el nivel de uso del PAC (Plan Anual Mensualizado de Caja) disponible del mes para los recursos de Gastos de Personal y de Transferencias Corrientes."]
[null,"TENDENCIA",null,null,"DESCENDENTE"]
[null,"FÓRMULA DEL INDICADOR",null,null,"VARIABLE 1:",null,{"$f":"\"Valor PAC Gastos de Personal y Transferencias Corrientes sin ejecutar en el mes\"","v":"Valor PAC Gastos de Personal y Transferencias Corrientes sin ejecutar en el mes"},null,null,null,null,null,"FUENTE DE INFORMACIÓN",null,null,null,"Consulta INPANUT en el sistema SIIF NACIÓN"]
[null,null,null,null,"VARIABLE 2:",null,"Valor PAC \"Gastos de Personal\" y \"Transferencias Corrientes\" Máximo disponible en el mes",null,null,null,null,null,"FUENTE DE INFORMACIÓN",null,null,null,"Consulta INPANUT en el sistema SIIF NACIÓN"]
[]
[null,"FRECUENCIA DE RECOLECCIÓN Y ANÁLISIS DE DATOS",null,null,null,null,"MENSUAL",null,"RESPONSABLE DEL INDICADOR",null,null,"Tesorero",null,null,null,null,null,null,"LINEA BASE",null,0.05]
[null,"TIPO DE INDICADOR",null,null,"EFICACIA",null,"META DEL INDICADOR",null,null,0.05,null,"DESCRIPCIÓN DE LA META",null,null,null,"Para la sumatoria de PAC de los conceptos \"Gastos de Personal\" y \"Transferencias Corrientes\" se espera que el valor del PAC no ejecutado, es decir, no pagado durante el mes sea igual o inferior al 5% del total de PAC disponible durante dicho periodo."]
[]
[null,"3. INFORMACIÓN DE GESTIÓN Y ANÁLISIS"]
[]
[null,"CONCEPTO",null,null,"Enero","Febrero","Marzo","1er Trimestre","Abril","Mayo","Junio","2do Trimestre","1er Semestre","Julio","Agosto","Septiembre","3er Trimestre","Octubre","Noviembre","Diciembre","4to Trimestre","2do Semestre","Anual\nAcumulado"]
[null,"Resultado Variable 1",null,null,null,null,null,{"$f":"+IFERROR(SUM(E32:G32),\"\")","v":0},null,null,null,{"$f":"+IFERROR(SUM(I32:K32),\"\")","v":0},{"$f":"IFERROR(SUM(E32:G32,I32:K32),\"\")","v":0},null,null,null,{"$f":"+IFERROR(SUM(N32:P32),\"\")","v":0},null,null,null,{"$f":"+IFERROR(SUM(R32:T32),\"\")","v":0},{"$f":"IFERROR(SUM(N32:P32,R32:T32),\"\")","v":0},{"$f":"IF(SUM(E32,F32,G32,I32,J32,K32,N32,O32,P32,R32,S32,T32)=0,\"\",SUM(E32,F32,G32,I32,J32,K32,N32,O32,P32,R32,S32,T32))","v":""}]
[null,"Resultado Variable 2",null,null,null,null,null,{"$f":"+IFERROR(SUM(E33:G33),\"\")","v":0},null,null,null,{"$f":"+IFERROR(SUM(I33:K33),\"\")","v":0},{"$f":"IFERROR(SUM(E33:G33,I33:K33),\"\")","v":0},null,null,null,{"$f":"+IFERROR(SUM(N33:P33),\"\")","v":0},null,null,null,{"$f":"+IFERROR(SUM(R33:T33),\"\")","v":0},{"$f":"IFERROR(SUM(N33:P33,R33:T33),\"\")","v":0},{"$f":"IF(SUM(E33,F33,G33,I33,J33,K33,N33,O33,P33,R33,S33,T33)=0,\"\",SUM(E33,F33,G33,I33,J33,K33,N33,O33,P33,R33,S33,T33))","v":""}]
[null,"Resultado del Indicador Ascendente",null,null,{"$f":"IF($E$22=\"DESCENDENTE\",\"\",IF($E$22=\"\",\"\",IFERROR(E32/E33,\"\")))","v":""},"","","","","","","","","","","","","","","","","",""]
[null,"Resultado del Indicador Descendente",null,null,{"$f":"IF($E$22=\"ASCENDENTE\",\"\",IF($E$22=\"\",\"\",IFERROR(E32/E33,\"\")))","v":""},"","","","","","","","","","","","","","","","","",""]
[null,"Meta para el Periodo",null,null,{"$f":"IF($J$27=\"\",\"\",$J$27)","v":0.05},0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05]
[null,"Resultado con Respecto a la Meta",null,null,{"$f":"IF(AND(E34<>\"\",E36<>\"\"),E34/E36,\"\")","v":""},"","","","","","","","","","","","","","","","","",{"$f":"IFERROR(IF(AND(W34=\"\",W36=\"\"),\"\",W34/W36),\"\")","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"ANÁLISIS DE RESULTADOS"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"PROPUESTA DE MEJORAMIENTO "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"SE ABRE ACCIÓN CORRECTIVA (CUANDO EL RESULTADO DEL INDICADOR SE ENCUENTRA EN SEMAFORO ROJO):",null,null,null,"SI",null,"NO","X","CONSECUTIVO ACPM"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"SE ABRE ACCIÓN DE MEJORA (CUANDO EL RESULTADO DEL INDICADOR SE ENCUENTRA EN VERDE PERO SE CONSIDERA NECESARIO):",null,null,null,"SI",null,"NO","X","CONSECUTIVO ACPM"]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Trimestre 1","Trimestre 2 - Semestre 1","Trimestre 3","Trimestre 4 - Semestre 2","Anual - Acumulado"]
[null,null,null,null,null,{"$f":"+H34","v":""},{"$f":"+L34","v":""},{"$f":"+Q34","v":""},{"$f":"+U34","v":""},{"$f":"+W34","v":""}]
[null,null,null,null,null,{"$f":"+H36","v":0.05},{"$f":"+L36","v":0.05},{"$f":"+Q36","v":0.05},{"$f":"+U36","v":0.05},{"$f":"+W36","v":0.05}]
[null,null,null,null,null,{"$f":"+H37","v":""},{"$f":"+L37","v":""},{"$f":"+Q37","v":""},{"$f":"+U37","v":""},{"$f":"+W37","v":""}]